﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

-- AgreementState
SET IDENTITY_INSERT [dbo].[AgreementState] ON
INSERT INTO [dbo].[AgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(0,NEWID(),0,GETDATE(),GETDATE(),NULL,N'未售',N'33FF00');
INSERT INTO [dbo].[AgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'小定',N'0000FF');
INSERT INTO [dbo].[AgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'大定',N'FFFF00');
INSERT INTO [dbo].[AgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已签',N'FF0000');
INSERT INTO [dbo].[AgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(8,NEWID(),0,GETDATE(),GETDATE(),NULL,N'退定',N'00FF00');
SET IDENTITY_INSERT [dbo].[AgreementState] OFF

-- AlertType
SET IDENTITY_INSERT [dbo].[AlertType] ON
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(10,NEWID(),0,GETDATE(),GETDATE(),NULL,N'客户回访计划',N'上次与客户联系时间为{0}，请再次通过电话和短信联系客户。',7);
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(20,NEWID(),0,GETDATE(),GETDATE(),NULL,N'售房小定解除期限',N'此客户小定协议约定的期限为{0}，请电话和短信提醒客户。',-2);
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(30,NEWID(),0,GETDATE(),GETDATE(),NULL,N'售房约定签约日期',N'此客户大定协议约定的签约日为{0}，请电话和短信提醒客户。',-3);
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(40,NEWID(),0,GETDATE(),GETDATE(),NULL,N'售房欠款催收',N'此客户承若{0}付款，但到现在未付，请联系客户确认。',-1);
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'租房约定签约日期',N'此客户租房协议约定的签约日为{0}，请电话和短信提醒客户。',-3);
INSERT INTO [dbo].[AlertType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[DescriptionTemplate],[DefaultReminderDays]) VALUES(110,NEWID(),0,GETDATE(),GETDATE(),NULL,N'租房欠款催收',N'此客户承若{0}付款，但到现在未付，请联系客户确认。',-1);
SET IDENTITY_INSERT [dbo].[AlertType] OFF

-- BuildingState
SET IDENTITY_INSERT [dbo].[BuildingState] ON
INSERT INTO [dbo].[BuildingState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'可用');
INSERT INTO [dbo].[BuildingState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'冻结');
SET IDENTITY_INSERT [dbo].[BuildingState] OFF

-- BuildingType
SET IDENTITY_INSERT [dbo].[BuildingType] ON
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'多层');
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'独栋');
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'双拼');
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'叠加');
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'小高层');
INSERT INTO [dbo].[BuildingType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'高层');
SET IDENTITY_INSERT [dbo].[BuildingType] OFF

-- BusinessType
SET IDENTITY_INSERT [dbo].[BusinessType] ON
INSERT INTO [dbo].[BusinessType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'售楼');
INSERT INTO [dbo].[BusinessType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'租赁');
SET IDENTITY_INSERT [dbo].[BusinessType] OFF

-- CommunicationType
SET IDENTITY_INSERT [dbo].[CommunicationType] ON
INSERT INTO [dbo].[CommunicationType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'来电');
INSERT INTO [dbo].[CommunicationType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'回电');
INSERT INTO [dbo].[CommunicationType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'来访');
INSERT INTO [dbo].[CommunicationType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'回访');
SET IDENTITY_INSERT [dbo].[CommunicationType] OFF

-- DealingReason
SET IDENTITY_INSERT [dbo].[DealingReason] ON
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'价格适合');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'户型适合');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'配套设施适合');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'地段适合');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'环境适合');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'认可品质');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(7,NEWID(),0,GETDATE(),GETDATE(),NULL,N'优于竟争对手');
INSERT INTO [dbo].[DealingReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[DealingReason] OFF

-- DeliveryMode
SET IDENTITY_INSERT [dbo].[DeliveryMode] ON
INSERT INTO [dbo].[DeliveryMode]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'现房');
INSERT INTO [dbo].[DeliveryMode]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'期房');
SET IDENTITY_INSERT [dbo].[DeliveryMode] OFF

-- Facility
SET IDENTITY_INSERT [dbo].[Facility] ON
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'自来水');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'煤气');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'电');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'照明');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'空调');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'电视');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(7,NEWID(),0,GETDATE(),GETDATE(),NULL,N'电话');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(8,NEWID(),0,GETDATE(),GETDATE(),NULL,N'网络');
INSERT INTO [dbo].[Facility]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[Facility] OFF

-- InformationSource
SET IDENTITY_INSERT [dbo].[InformationSource] ON
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'户外广告');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'报纸');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'房展');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'网络');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'手机短信');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'电视');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(7,NEWID(),0,GETDATE(),GETDATE(),NULL,N'路过');
INSERT INTO [dbo].[InformationSource]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[InformationSource] OFF

-- LeaseAgreementState
SET IDENTITY_INSERT [dbo].[LeaseAgreementState] ON
INSERT INTO [dbo].[LeaseAgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(0,NEWID(),0,GETDATE(),GETDATE(),NULL,N'未售',N'33FF00');
INSERT INTO [dbo].[LeaseAgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'预定',N'FFFF00');
INSERT INTO [dbo].[LeaseAgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已租',N'FF0000');
INSERT INTO [dbo].[LeaseAgreementState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'退租',N'00FF00');
SET IDENTITY_INSERT [dbo].[LeaseAgreementState] OFF

-- LeasePaymentType
SET IDENTITY_INSERT [dbo].[LeasePaymentType] ON
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(11,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付一押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(12,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付一押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(13,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付一押三');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(21,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付二押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(22,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付二押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(23,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付二押三');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(31,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付三押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(32,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付三押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(33,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付三押三');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(41,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付四押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(42,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付四押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(43,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付四押三');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(51,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付五押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(52,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付五押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(53,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付五押三');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(61,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付六押一');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(62,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付六押二');
INSERT INTO [dbo].[LeasePaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(63,NEWID(),0,GETDATE(),GETDATE(),NULL,N'付六押三');
SET IDENTITY_INSERT [dbo].[LeasePaymentType] OFF

-- Motivation
SET IDENTITY_INSERT [dbo].[Motivation] ON
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(0,NEWID(),0,GETDATE(),GETDATE(),NULL,N'不确定');
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'居住');
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'投资');
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'办公');
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'出租');
INSERT INTO [dbo].[Motivation]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[Motivation] OFF

-- PaymentType
SET IDENTITY_INSERT [dbo].[PaymentType] ON
INSERT INTO [dbo].[PaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一次性');
INSERT INTO [dbo].[PaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'分期');
INSERT INTO [dbo].[PaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'按揭');
INSERT INTO [dbo].[PaymentType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'分期加按揭');
SET IDENTITY_INSERT [dbo].[PaymentType] OFF

-- PriceRange
SET IDENTITY_INSERT [dbo].[PriceRange] ON
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(0,NEWID(),0,GETDATE(),GETDATE(),NULL,N'不确定');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'5000至8000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(8000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'8000至12000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(12000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'12000至16000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(16000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'16000至20000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(20000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'20000至25000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(25000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'25000至30000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(30000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'30000至37000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(37000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'37000至45000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(45000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'45000至55000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(55000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'55000至67000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(67000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'67000至80000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(80000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'80000至95000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(95000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'95000至110000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(110000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'110000至130000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(130000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'130000至150000');
INSERT INTO [dbo].[PriceRange]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1000000,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[PriceRange] OFF

-- ProjectState
SET IDENTITY_INSERT [dbo].[ProjectState] ON
INSERT INTO [dbo].[ProjectState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'可用');
INSERT INTO [dbo].[ProjectState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'冻结');
SET IDENTITY_INSERT [dbo].[ProjectState] OFF

-- PropertyState
SET IDENTITY_INSERT [dbo].[PropertyState] ON
INSERT INTO [dbo].[PropertyState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'空闲',N'00C300');
INSERT INTO [dbo].[PropertyState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'保留',N'80FFFF');
INSERT INTO [dbo].[PropertyState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'预定',N'FF00FF');
INSERT INTO [dbo].[PropertyState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已租',N'FF0000');
SET IDENTITY_INSERT [dbo].[PropertyState] OFF

-- ReceiptType
SET IDENTITY_INSERT [dbo].[ReceiptType] ON
INSERT INTO [dbo].[ReceiptType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一次性或首付款');
INSERT INTO [dbo].[ReceiptType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'分期款');
INSERT INTO [dbo].[ReceiptType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'公积金按揭款');
INSERT INTO [dbo].[ReceiptType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'商业按揭款');
SET IDENTITY_INSERT [dbo].[ReceiptType] OFF

-- RequirementLevel
SET IDENTITY_INSERT [dbo].[RequirementLevel] ON
INSERT INTO [dbo].[RequirementLevel]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'非常有意向');
INSERT INTO [dbo].[RequirementLevel]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一般');
INSERT INTO [dbo].[RequirementLevel]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'不确定');
SET IDENTITY_INSERT [dbo].[RequirementLevel] OFF

-- Resistance
SET IDENTITY_INSERT [dbo].[Resistance] ON
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'价格偏高');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'户型不佳');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'配套设施不佳');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'地段不佳');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'环境不佳');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'竞争影响');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(7,NEWID(),0,GETDATE(),GETDATE(),NULL,N'犹豫观望');
INSERT INTO [dbo].[Resistance]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[Resistance] OFF

-- Role
SET IDENTITY_INSERT [dbo].[Role] ON
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'系统管理员');
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'总经理');
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'项目经理');
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'专案经理');
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'专案助理');
INSERT INTO [dbo].[Role]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'开发商代表');
SET IDENTITY_INSERT [dbo].[Role] OFF

-- RoomState
SET IDENTITY_INSERT [dbo].[RoomState] ON
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'可售',N'00C300');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'保留',N'80FFFF');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'小定',N'800040');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'大定',N'FF00FF');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已签',N'FFFF00');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已登记',N'FF0000');
INSERT INTO [dbo].[RoomState]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Color]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'不可售',N'FFFFFF');
SET IDENTITY_INSERT [dbo].[RoomState] OFF

-- RoomType
SET IDENTITY_INSERT [dbo].[RoomType] ON
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一室无阳台',1,0,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(101,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一室',1,0,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(110,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一室一厅无阳台',1,1,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(111,NEWID(),0,GETDATE(),GETDATE(),NULL,N'一室一厅',1,1,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(200,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室无阳台',2,0,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(201,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室',2,0,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(210,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室一厅无阳台',2,1,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(211,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室一厅',2,1,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(220,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室两厅无阳台',2,2,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(221,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室两厅',2,2,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(231,NEWID(),0,GETDATE(),GETDATE(),NULL,N'两室两厅两卫',2,2,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(300,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室无阳台',3,0,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(301,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室',3,0,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(310,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室一厅无阳台',3,1,1,1,0);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(311,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室一厅',3,1,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(321,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室两厅',3,2,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(322,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室两厅双阳台',3,2,1,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(331,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室两厅两卫',3,2,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(332,NEWID(),0,GETDATE(),GETDATE(),NULL,N'三室两厅两卫双阳台',3,2,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(411,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室一厅',4,1,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(412,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室一厅双阳台',4,1,1,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(421,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室一厅两卫',4,1,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(422,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室一厅两卫双阳台',4,1,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(431,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室两厅',4,2,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(432,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室两厅双阳台',4,2,1,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(441,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室两厅两卫',4,2,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(442,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室两厅两卫双阳台',4,2,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(451,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室三厅两卫',4,3,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(452,NEWID(),0,GETDATE(),GETDATE(),NULL,N'四室三厅两卫双阳台',4,3,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(511,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室一厅',5,1,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(512,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室一厅双阳台',5,1,1,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(521,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室一厅两卫',5,1,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(522,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室一厅两卫双阳台',5,1,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(531,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室两厅',5,2,1,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(532,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室两厅双阳台',5,2,1,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(541,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室两厅两卫',5,2,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(542,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室两厅两卫双阳台',5,2,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(551,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室三厅两卫',5,3,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(552,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室三厅两卫双阳台',5,3,2,1,2);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(561,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室四厅两卫',5,4,2,1,1);  
INSERT INTO [dbo].[RoomType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[RoomsNumber],[HallsNumber],[ToiletsNumber],[KitchensNumber],[BalconiesNumber]) VALUES(562,NEWID(),0,GETDATE(),GETDATE(),NULL,N'五室四厅两卫双阳台',5,4,2,1,2);  
SET IDENTITY_INSERT [dbo].[RoomType] OFF

-- ReportType
SET IDENTITY_INSERT [dbo].[ReportType] ON
INSERT INTO [dbo].[ReportType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'日报');
INSERT INTO [dbo].[ReportType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'周报');
INSERT INTO [dbo].[ReportType]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'月报');
SET IDENTITY_INSERT [dbo].[ReportType] OFF

-- Usage
SET IDENTITY_INSERT [dbo].[Usage] ON
INSERT INTO [dbo].[Usage]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'住宅');
INSERT INTO [dbo].[Usage]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'商铺');
INSERT INTO [dbo].[Usage]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'办公室');
INSERT INTO [dbo].[Usage]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'车位');
INSERT INTO [dbo].[Usage]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[Usage] OFF

-- WithdrawalReason
SET IDENTITY_INSERT [dbo].[WithdrawalReason] ON
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'资金不足');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,N'竞争影响');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,N'价格偏高');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,N'户型不合适');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,N'配套设施不合适');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(6,NEWID(),0,GETDATE(),GETDATE(),NULL,N'犹豫观望');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(7,NEWID(),0,GETDATE(),GETDATE(),NULL,N'家庭原因');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(8,NEWID(),0,GETDATE(),GETDATE(),NULL,N'地段不合适');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(9,NEWID(),0,GETDATE(),GETDATE(),NULL,N'环境不合适');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(10,NEWID(),0,GETDATE(),GETDATE(),NULL,N'没有选到合适房子');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(11,NEWID(),0,GETDATE(),GETDATE(),NULL,N'换房');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(12,NEWID(),0,GETDATE(),GETDATE(),NULL,N'急需用钱');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(13,NEWID(),0,GETDATE(),GETDATE(),NULL,N'已在别处购房');
INSERT INTO [dbo].[WithdrawalReason]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name]) VALUES(100,NEWID(),0,GETDATE(),GETDATE(),NULL,N'其它');
SET IDENTITY_INSERT [dbo].[WithdrawalReason] OFF

-- ProjectAlertTypeRequirementLevelSetting
--SET IDENTITY_INSERT [dbo].[ProjectAlertTypeRequirementLevelSetting] ON
--INSERT INTO [dbo].[ProjectAlertTypeRequirementLevelSetting]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[AlertTypeId],[RequirementLevelId],[ReminderDays]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,10,1,3);
--INSERT INTO [dbo].[ProjectAlertTypeRequirementLevelSetting]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[AlertTypeId],[RequirementLevelId],[ReminderDays]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,10,2,7);
--INSERT INTO [dbo].[ProjectAlertTypeRequirementLevelSetting]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[AlertTypeId],[RequirementLevelId],[ReminderDays]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,10,3,30);
--SET IDENTITY_INSERT [dbo].[ProjectAlertTypeRequirementLevelSetting] OFF




-- Company
SET IDENTITY_INSERT [dbo].[Company] ON
INSERT INTO [dbo].[Company]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[Name],[Description]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,N'上海领汇房地产营销策划有限公司',NULL);
SET IDENTITY_INSERT [dbo].[Company] OFF

-- Department
SET IDENTITY_INSERT [dbo].[Department] ON
INSERT INTO [dbo].[Department]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'客服部');
INSERT INTO [dbo].[Department]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name]) VALUES(2,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'市场部');
INSERT INTO [dbo].[Department]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name]) VALUES(3,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'财务部');
INSERT INTO [dbo].[Department]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name]) VALUES(4,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'行政层');
INSERT INTO [dbo].[Department]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name]) VALUES(5,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'管理层');
SET IDENTITY_INSERT [dbo].[Department] OFF

-- District
SET IDENTITY_INSERT [dbo].[District] ON
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(101,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'北京',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(102,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'天津',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(103,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'沈阳',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(104,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'大连',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(105,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'长春',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(106,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'哈尔滨',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(107,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'石家庄',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(108,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'太原',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(109,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'呼和浩特',N'华北东北');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(201,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'上海',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(202,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'杭州',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(203,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'南京',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(204,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'苏州',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(205,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'无锡',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(206,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'济南',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(207,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'厦门',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(208,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'宁波',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(209,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'福州',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(210,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'青岛',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(211,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'合肥',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(212,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'扬州',N'华东');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(301,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'武汉',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(302,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'郑州',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(303,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'长沙',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(304,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'南昌',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(305,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'贵阳',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(306,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'西宁',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(307,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'成都',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(308,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'重庆',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(309,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'西安',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(310,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'昆明',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(311,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'兰州',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(312,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'乌鲁木齐',N'中部西部');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(401,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'广州',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(402,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'深圳',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(403,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'香港',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(404,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'佛山',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(405,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'珠海',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(406,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'东莞',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(407,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'三亚',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(408,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'海口',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(409,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'澳门',N'华南');
INSERT INTO [dbo].[District]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[Name],[Region]) VALUES(410,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'南宁',N'华南');
SET IDENTITY_INSERT [dbo].[District] OFF

-- User
SET IDENTITY_INSERT [dbo].[User] ON
INSERT INTO [dbo].[User]([Id],[RowId],[IsDeleted],[CreatedDate],[ModifiedDate],[ModifiedByUserId],[CompanyId],[UserName],[Name],[Mobile],[Email],[Password],[PasswordQuestion],[PasswordAnswer],[IsApproved],[IsLockedOut],[LastLoginDate],[LastPasswordChangedDate],[LastLockoutDate],[FailedPasswordAttemptCount],[FailedPasswordAttemptWindowStart],[FailedPasswordAnswerAttemptCount],[FailedPasswordAnswerAttemptWindowStart],[LastActivityDate],[RoleId],[Comment]) VALUES(1,NEWID(),0,GETDATE(),GETDATE(),NULL,1,N'Admin',N'管理员',N'13501818779',N'hongliyu2002@hotmail.com',N'1',N'谁是法老？',N'Fuck Boss',1,0,NULL,NULL,NULL,0,NULL,0,NULL,NULL,1,NULL);
SET IDENTITY_INSERT [dbo].[User] OFF
